Oracle manages database access permissions using users and roles. Users own schema objects (for example, tables, views) and can assign privileges on those objects to other users to control who has access to which objects.
Navicat provides User toadd, duplicate, edit, delete users/roles, grant/revoke server privileges and privileges on the selected schema objects. The object pane displays all the users/roles that exist in the server.
In addition to the user accounts that you create, the database includes a number of user accounts that are automatically created upon installation. Administrative accounts: SYS, SYSTEM, SYSMAN, and DBSNMP. Administrative accounts are highly privileged accounts to perform administrative tasks such as starting and stopping the database, managing database memory and storage, creating and managing database users, and so on. Your database may also include sample schemas (SCOTT, HR, OE, OC, PM, IX and SH), which are a set of interlinked schemas that enable Oracle documentation and Oracle instructional materials to illustrate common database tasks.
Manager User
Just simply click -> User to open an object pane for User. A control-click displays the popup menu or use the object pane toolbar, allowing you to add, edit and delete users.
Add User
To add a new user
- Select the connection you wish to set privileges in the navigation pane.
- Click
-> User to open the User showing the user list.
- Click the
from the object pane toolbar or control-click and select New User from the popup menu.
- Edit user properties and privileges on the appropriate tabs of the User Designer.
To create a new user with modification as one of the existing users
- Select the connection you wish to set privileges in the navigation pane.
- Click
to open the User showing the user list.
- Select a user to edit in the object pane.
- Control-click the user and select Duplicate User from the popup menu.
- Edit user properties and privileges on the appropriate tabs of the User Designer.
Edit User
To edit an existing user
- Select the connection you wish to set privileges in the navigation pane.
- Click
-> User to open the User showing the user list.
- Select a user to edit in the object pane.
- Click the
from the object pane toolbar or control-click the user and select Design User from the popup menu.
- Edit user properties and privileges on the appropriate tabs of the User Designer.
Delete User
To delete a user
- Select the connection you wish to set privileges in the navigation pane.
- Click
-> User to open the User showing the user list.
- Select a user to delete in the object pane.
- Click the
from the object pane toolbar or control-click the user and select Delete User from the popup menu.
- Confirm deleting in the dialog window.
Manage Role
Just simply click -> Role to open an object pane for Role. A control-click displays the popup menu or use the object pane toolbar, allowing you to add, edit and delete roles.
Add Role
To add a new role
- Select the connection you wish to set privileges in the navigation pane.
- Click
-> Role to open the Role showing the role list.
- Click the
from the object pane toolbar or control-click and select New Role from the popup menu.
- Edit role properties and privileges on the appropriate tabs of the Role Designer.
To create a new role with modification as one of the existing rolers
- Select the connection you wish to set privileges in the navigation pane.
- Click
to open the Role showing the role list.
- Select a role to edit in the object pane.
- Control-click the role and select Duplicate Role from the popup menu.
- Edit role properties and privileges on the appropriate tabs of the Role Designer.
Edit Role
To edit an existing role
- Select the connection you wish to set privileges in the navigation pane.
- Click
-> Role to open the Role showing the role list.
- Select a role to edit in the object pane.
- Click the
from the object pane toolbar or control-click the role and select Design Role from the popup menu.
- Edit role properties and privileges on the appropriate tabs of the Role Designer.
Delete Role
To delete a role
- Select the connection you wish to set privileges in the navigation pane.
- Click
-> Role to open the Role showing the role list.
- Select a role to delete in the object pane.
- Click the
from the object pane toolbar or control-click the role and select Delete Role from the popup menu.
- Confirm deleting in the dialog window.
Privilege Manager
To edit privilege according to the database objects by using Privilege Manager
- Select the connection you wish to set privileges in the navigation pane.
- Choose Connection -> Set Privileges or control-click the connection and select Set Privileges from the popup menu to open the Privilege Manager window and set privileges.